package com.sto.stoapp.db.constant;

public interface StoOrderConstant extends StoBaseConstant {

	// 收件员编号
	public static final String EMP_CODE = "empCode";
	// 订单编号
	public static final String ODER_NO = "oderNo";
	// 订单状态
	public static final String ORDER_STATUS = "orderStatus";
	// 下单时间
	public static final String ODER_TIME = "oderTime";
	// 订单催促标识
	public static final String URGE_TAG = "urgeTag";
	// 寄件联系人
	public static final String CONTACT_NAME = "contactName";
	// 寄件联系电话
	public static final String CONTACT_PHONE = "contactPhone";
	// 寄件联系手机
	public static final String CONTACT_MOBILE_PHONE = "contactMobilePhone";
	// 寄件客户地址
	public static final String CONTACT_ADDRESS = "contactAddress";
	// 目的地
	public static final String DES_AREA_CODE = "desAreaCode";
	// 客户编号
	public static final String CUSTOMER_NO = "customerNo";
	// 发件客户
	public static final String CUSTOMER_NAME = "customerName";
	// 客户备注
	public static final String CUSTOMER_REMARK = "customerRemark";

	/**
	 * 订单数据库表名
	 */
	public static final String ORDER_DOWNLOAD_TABLE = "order_download_table";

	/**
	 * 创建订单下载数据库表
	 */
	public static final String CREATE_ORDER_TABLE = "CREATE TABLE "
			+ " if not exists "
			+ ORDER_DOWNLOAD_TABLE
			+ "("
			+ "id  INTEGER PRIMARY KEY AUTOINCREMENT"
			+ ","
			+ EMP_CODE
			+ " char(20)"
			+ ","
			+ ODER_NO
			+ " text unique"
			+ ","
			+ ORDER_STATUS
			+ " text "
			+ ","
			+ ODER_TIME
			+ " text"
			+ ","
			+ URGE_TAG
			+ " text"
			+ ","
			+ CONTACT_NAME
			+ " text"
			+ ","
			+ CONTACT_PHONE
			+ " text"
			+ ","
			+ CONTACT_MOBILE_PHONE
			+ " text"
			+ ","
			+ CONTACT_ADDRESS
			+ " text"
			+ ","
			+ DES_AREA_CODE
			+ " text"
			+ ","
			+ CUSTOMER_NO
			+ " text"
			+ ","
			+ CUSTOMER_NAME
			+ " text"
			+ ","
			+ CUSTOMER_REMARK
			+ " text"
			+ ","
			+ STATUS
			+ " text"
			+ ","
			+ BACKUPS_ONE
			+ " char(50)"
			+ ","
			+ BACKUPS_FOUR
			+ " char(64)"
			+ ","
			+ BACKUPS_TWO
			+ " char(200)"
			+ ","
			+ BACKUPS_THREE
			+ " char(500)"
			+ ")";

	/**
	 * 删除员工数据库表
	 */
	public static final String DROP_SALES_TABLE = "drop table if exists "
			+ ORDER_DOWNLOAD_TABLE;
}
